Engine(sqlite:///spotify.db)
* sqlite:///spotify.db Done.
| index | year | price_per_stream |
|---|---|---|
| 0 | 2010 | 0.005 |
| 1 | 2011 | 0.005 |
| 2 | 2012 | 0.006 |
| 3 | 2013 | 0.007 |
| 4 | 2014 | 0.0045 |
| 5 | 2015 | 0.004 |
| 6 | 2016 | 0.0038 |
| 7 | 2017 | 0.0036 |
| 8 | 2018 | 0.0034 |
| 9 | 2019 | 0.0033 |
| 10 | 2020 | 0.0032 |
| 11 | 2021 | 0.0031 |
| 12 | 2022 | 0.0037 |
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db
Done.
AVG(profit) creation_date
0 2747.042096 2017-01-01
1 2849.741034 2017-01-02
2 3092.437046 2017-01-03
3 3151.006815 2017-01-04
4 3177.810287 2017-01-05
... ... ...
1601 3942.517396 2021-07-13
1602 3967.764816 2021-07-14
1603 4006.528743 2021-07-15
1604 4607.534448 2021-07-16
1605 4263.567322 2021-07-17
[1606 rows x 2 columns]
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db
Done.
genre average_profit
0 indie rock italiano 12332.514798
1 australian pop 8577.263236
2 new wave pop 8164.128748
3 cali rap 7183.971769
4 mexican hip hop 6671.157609
.. ... ...
379 pop edm 1521.964714
380 australian electropop 1512.644908
381 anime 1479.650400
382 indie electropop 1395.527600
383 indietronica 1227.610800
[384 rows x 2 columns]
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.
* sqlite:///spotify.db Done.